from sqlalchemy import Column, Integer, String, DateTime, JSON, func, text, Text
from api_server.db.base import Base


class ZRectifyData(Base):
    __tablename__ = 'z_rectify_data'
    __table_args__ = {'comment': '整改台账'}
    id = Column(Integer, primary_key=True, autoincrement=True, comment='主键id')
    audit_report_name = Column(String(1024), comment='审计报告名称')
    audit_report_date = Column(String(1024), comment='审计报告发布日期')
    audit_unit = Column(String(1024), comment='被审计单位')
    question_type = Column(String(255), comment='问题类型')
    question_summary = Column(Text, comment='问题概要')
    question_detail = Column(Text, comment='问题详细描述')
    audit_money = Column(String(255), comment='审计风险金额(元)')
    rectify_advice = Column(Text, comment='整改建议')
    audit_manager = Column(String(255), comment='审计组联系人')
    audit_dept = Column(String(255), comment='责任部门')
    rectify_hand = Column(Text, comment='整改落实情况')
    recitify_result = Column(Text, comment='整改结果确认')
    audit_code = Column(String(1024), comment='整改事项编号')
    files_path = Column(String(2048), comment='文件所在位置，相对路径，多个逗号隔开')
    created_time = Column(DateTime, comment='创建时间')
